Apple Reference & Presentation Library 1993 Spring/ARPL-Spring-93-Partner-Edition.iso/Applications/Databases/GQL V3.0 Demo/USA Sales Information/USA Sales Information.rsrc/gDEM_15947_Sales by City2 (5000)

Text File | 1992-01-27 | 195 b | 1 lines

select customer.cust_city, AVG (orders.ord_amount) from customer, orders where ((orders.ord_amount >= $5000)) and customer.cust_num = orders.cust_nr group by customer.cust_city order by 2 desc ;